<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<%@ page import="java.sql.*, javax.sql.*, javax.naming.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>

<%
	Connection conn = null;
	String sql = null;
	PreparedStatement stmt = null;
	ResultSet rs=null;
	try {
		Context cxt = new InitialContext();
		DataSource ds = (DataSource) cxt.lookup("java:/comp/env/jdbc/sqlserver");
		conn = ds.getConnection();
		sql = "select * from  t_emp";
		stmt = conn.prepareStatement(sql);
		rs = stmt.executeQuery();
		if (rs.next()) {
			out.println(rs.getString("cId"));
			out.println(rs.getString("cEmpNo"));
			out.println("连接ok");
		} else {
			out.println("rs.next() fail");
		}
		rs.close();

	} catch (Exception e) {
		out.println("连接失败:" + e.getMessage());
		//e.printStackTrace();
	}
%>

<body>

</body>
</html>